Dataset statistics
| Number of variables | 28 |
|---|---|
| Number of observations | 2524 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 552.2 KiB |
| Average record size in memory | 224.1 B |
Variable types
| Numeric | 14 |
|---|---|
| Categorical | 5 |
| Unsupported | 9 |
nombre has a high cardinality: 2524 distinct values | High cardinality |
cedula is highly correlated with saldo_total and 1 other fields | High correlation |
no_hijos is highly correlated with activos and 2 other fields | High correlation |
activos is highly correlated with no_hijos and 3 other fields | High correlation |
pasivos is highly correlated with no_hijos and 2 other fields | High correlation |
patrimonio is highly correlated with activos | High correlation |
gastos is highly correlated with no_hijos and 2 other fields | High correlation |
saldo_total is highly correlated with cedula and 1 other fields | High correlation |
mora is highly correlated with cedula and 1 other fields | High correlation |
activos is highly correlated with patrimonio | High correlation |
patrimonio is highly correlated with activos | High correlation |
dias_mora is highly correlated with mora | High correlation |
mora is highly correlated with dias_mora | High correlation |
cedula is highly correlated with mora | High correlation |
activos is highly correlated with pasivos and 2 other fields | High correlation |
pasivos is highly correlated with activos and 1 other fields | High correlation |
patrimonio is highly correlated with activos | High correlation |
gastos is highly correlated with activos and 1 other fields | High correlation |
mora is highly correlated with cedula | High correlation |
antiguedad is highly correlated with edad | High correlation |
edad is highly correlated with antiguedad | High correlation |
activos is highly correlated with patrimonio | High correlation |
patrimonio is highly correlated with activos | High correlation |
salario is highly correlated with saldo_total | High correlation |
calificacion is highly correlated with dias_mora | High correlation |
dias_mora is highly correlated with calificacion and 1 other fields | High correlation |
saldo_total is highly correlated with salario | High correlation |
mora is highly correlated with dias_mora | High correlation |
activos is highly skewed (γ1 = 38.47219861) | Skewed |
patrimonio is highly skewed (γ1 = 38.47257644) | Skewed |
gastos is highly skewed (γ1 = 31.83263709) | Skewed |
mora is highly skewed (γ1 = 23.1708264) | Skewed |
cedula is uniformly distributed | Uniform |
nombre is uniformly distributed | Uniform |
cedula has unique values | Unique |
nombre has unique values | Unique |
tipo_vivienda is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ocupacion is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
nivel_academico is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
personas_a_cargo is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
tiene_casa is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
tiene_carro is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
estado_civil is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
tipo_contrato is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
entidad is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
antiguedad has 138 (5.5%) zeros | Zeros |
no_hijos has 1214 (48.1%) zeros | Zeros |
activos has 1005 (39.8%) zeros | Zeros |
pasivos has 1037 (41.1%) zeros | Zeros |
patrimonio has 1153 (45.7%) zeros | Zeros |
gastos has 882 (34.9%) zeros | Zeros |
dias_mora has 2266 (89.8%) zeros | Zeros |
saldo_total has 206 (8.2%) zeros | Zeros |
mora has 157 (6.2%) zeros | Zeros |
Reproduction
| Analysis started | 2022-02-19 22:06:09.725688 |
|---|---|
| Analysis finished | 2022-02-19 22:06:45.854548 |
| Duration | 36.13 seconds |
| Software version | pandas-profiling v3.1.1 |
| Download configuration | config.json |
| Distinct | 2524 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1271500 |
| Minimum | 10000 |
|---|---|
| Maximum | 2533000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.8 KiB |
Quantile statistics
| Minimum | 10000 |
|---|---|
| 5-th percentile | 136150 |
| Q1 | 640750 |
| median | 1271500 |
| Q3 | 1902250 |
| 95-th percentile | 2406850 |
| Maximum | 2533000 |
| Range | 2523000 |
| Interquartile range (IQR) | 1261500 |
Descriptive statistics
| Standard deviation | 728760.363 |
|---|---|
| Coefficient of variation (CV) | 0.5731501085 |
| Kurtosis | -1.2 |
| Mean | 1271500 |
| Median Absolute Deviation (MAD) | 631000 |
| Skewness | 1.34333 × 10-16 |
| Sum | 3209266000 |
| Variance | 5.310916667 × 1011 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 10000 | 1 | < 0.1% |
| 1696000 | 1 | < 0.1% |
| 1689000 | 1 | < 0.1% |
| 1690000 | 1 | < 0.1% |
| 1691000 | 1 | < 0.1% |
| 1692000 | 1 | < 0.1% |
| 1693000 | 1 | < 0.1% |
| 1694000 | 1 | < 0.1% |
| 1695000 | 1 | < 0.1% |
| 1697000 | 1 | < 0.1% |
| Other values (2514) | 2514 |
| Value | Count | Frequency (%) |
| 10000 | 1 | |
| 11000 | 1 | |
| 12000 | 1 | |
| 13000 | 1 | |
| 14000 | 1 | |
| 15000 | 1 | |
| 16000 | 1 | |
| 17000 | 1 | |
| 18000 | 1 | |
| 19000 | 1 |
| Value | Count | Frequency (%) |
| 2533000 | 1 | |
| 2532000 | 1 | |
| 2531000 | 1 | |
| 2530000 | 1 | |
| 2529000 | 1 | |
| 2528000 | 1 | |
| 2527000 | 1 | |
| 2526000 | 1 | |
| 2525000 | 1 | |
| 2524000 | 1 |
| Distinct | 2524 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.8 KiB |
| JORGE ELIECER ALDANA AMADOR | 1 |
|---|---|
| YASMINE ESTERLING RODRIGUEZ | 1 |
| ROSALBA BARRERA GUTIERREZ | 1 |
| FRANCIA ELENA SALAZAR SALAZAR | 1 |
| MARTHA YASMIN HERNANDEZ MORENO | 1 |
| Other values (2519) |
Length
| Max length | 39 |
|---|---|
| Median length | 26 |
| Mean length | 25.85697306 |
| Min length | 10 |
Characters and Unicode
| Total characters | 65263 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 2524 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | JORGE ELIECER ALDANA AMADOR |
|---|---|
| 2nd row | ELKIN ARLEY CASTRO VELANDIA |
| 3rd row | HERSSON FERNANDO FLOREZ MORENO |
| 4th row | BRAYAN ALEXANDER BARON ORTEGON |
| 5th row | CINDY MAYELA OCHOA HERNANDEZ |
Common Values
| Value | Count | Frequency (%) |
| JORGE ELIECER ALDANA AMADOR | 1 | < 0.1% |
| YASMINE ESTERLING RODRIGUEZ | 1 | < 0.1% |
| ROSALBA BARRERA GUTIERREZ | 1 | < 0.1% |
| FRANCIA ELENA SALAZAR SALAZAR | 1 | < 0.1% |
| MARTHA YASMIN HERNANDEZ MORENO | 1 | < 0.1% |
| LUZ AMPARO CORDOBA PALACIOS | 1 | < 0.1% |
| RAYNER EDUARDO LOZADA LOZANO | 1 | < 0.1% |
| RAQUEL AMADO MARTINEZ | 1 | < 0.1% |
| HECTOR MIGUEL TORRES GUETTE | 1 | < 0.1% |
| MARIA EUGENIA REATIGA BARAJAS | 1 | < 0.1% |
| Other values (2514) | 2514 |
Length
| Value | Count | Frequency (%) |
| maria | 146 | 1.6% |
| rodriguez | 125 | 1.3% |
| luz | 94 | 1.0% |
| hernandez | 82 | 0.9% |
| martinez | 80 | 0.9% |
| jose | 79 | 0.8% |
| moreno | 73 | 0.8% |
| gonzalez | 66 | 0.7% |
| garcia | 66 | 0.7% |
| luis | 65 | 0.7% |
| Other values (2129) | 8508 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 9315 | |
| 6865 | ||
| R | 5924 | 9.1% |
| E | 5835 | 8.9% |
| O | 4671 | 7.2% |
| I | 4368 | 6.7% |
| N | 3909 | 6.0% |
| L | 3623 | 5.6% |
| S | 2468 | 3.8% |
| D | 2260 | 3.5% |
| Other values (21) | 16025 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 58196 | |
| Space Separator | 6865 | 10.5% |
| Initial Punctuation | 200 | 0.3% |
| Other Punctuation | 1 | < 0.1% |
| Control | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 9315 | |
| R | 5924 | |
| E | 5835 | |
| O | 4671 | 8.0% |
| I | 4368 | 7.5% |
| N | 3909 | 6.7% |
| L | 3623 | 6.2% |
| S | 2468 | 4.2% |
| D | 2260 | 3.9% |
| M | 1920 | 3.3% |
| Other values (17) | 13903 |
Space Separator
| Value | Count | Frequency (%) |
| 6865 |
Initial Punctuation
| Value | Count | Frequency (%) |
| ‘ | 200 |
Other Punctuation
| Value | Count | Frequency (%) |
| ‰ | 1 |
Control
| Value | Count | Frequency (%) |
| | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 58196 | |
| Common | 7067 | 10.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 9315 | |
| R | 5924 | |
| E | 5835 | |
| O | 4671 | 8.0% |
| I | 4368 | 7.5% |
| N | 3909 | 6.7% |
| L | 3623 | 6.2% |
| S | 2468 | 4.2% |
| D | 2260 | 3.9% |
| M | 1920 | 3.3% |
| Other values (17) | 13903 |
Common
| Value | Count | Frequency (%) |
| 6865 | ||
| ‘ | 200 | 2.8% |
| ‰ | 1 | < 0.1% |
| | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 64859 | |
| None | 203 | 0.3% |
| Punctuation | 201 | 0.3% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 9315 | |
| 6865 | ||
| R | 5924 | 9.1% |
| E | 5835 | 9.0% |
| O | 4671 | 7.2% |
| I | 4368 | 6.7% |
| N | 3909 | 6.0% |
| L | 3623 | 5.6% |
| S | 2468 | 3.8% |
| D | 2260 | 3.5% |
| Other values (17) | 15621 |
None
| Value | Count | Frequency (%) |
| Ã | 202 | |
| | 1 | 0.5% |
Punctuation
| Value | Count | Frequency (%) |
| ‘ | 200 | |
| ‰ | 1 | 0.5% |
| Distinct | 36 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.457210777 |
| Minimum | 0 |
|---|---|
| Maximum | 36 |
| Zeros | 138 |
| Zeros (%) | 5.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 5 |
| Q3 | 10 |
| 95-th percentile | 24 |
| Maximum | 36 |
| Range | 36 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 7.348317631 |
|---|---|
| Coefficient of variation (CV) | 0.9853976039 |
| Kurtosis | 2.208946704 |
| Mean | 7.457210777 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 1.581106633 |
| Sum | 18822 |
| Variance | 53.997772 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 325 | |
| 3 | 245 | 9.7% |
| 1 | 240 | 9.5% |
| 5 | 231 | 9.2% |
| 4 | 211 | 8.4% |
| 6 | 182 | 7.2% |
| 0 | 138 | 5.5% |
| 7 | 124 | 4.9% |
| 8 | 87 | 3.4% |
| 11 | 68 | 2.7% |
| Other values (26) | 673 |
| Value | Count | Frequency (%) |
| 0 | 138 | |
| 1 | 240 | |
| 2 | 325 | |
| 3 | 245 | |
| 4 | 211 | |
| 5 | 231 | |
| 6 | 182 | |
| 7 | 124 | 4.9% |
| 8 | 87 | 3.4% |
| 9 | 52 | 2.1% |
| Value | Count | Frequency (%) |
| 36 | 16 | |
| 35 | 5 | 0.2% |
| 34 | 5 | 0.2% |
| 32 | 4 | 0.2% |
| 31 | 3 | 0.1% |
| 30 | 9 | |
| 29 | 5 | 0.2% |
| 28 | 12 | |
| 27 | 18 | |
| 26 | 19 |
activo
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.8 KiB |
| Activo | |
|---|---|
| Pendiente de validación | 1 |
Length
| Max length | 24 |
|---|---|
| Median length | 6 |
| Mean length | 6.007131537 |
| Min length | 6 |
Characters and Unicode
| Total characters | 15162 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Activo |
|---|---|
| 2nd row | Activo |
| 3rd row | Activo |
| 4th row | Activo |
| 5th row | Activo |
Common Values
| Value | Count | Frequency (%) |
| Activo | 2523 | |
| Pendiente de validación | 1 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| activo | 2523 | |
| pendiente | 1 | < 0.1% |
| de | 1 | < 0.1% |
| validaciã³n | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 2526 | |
| c | 2524 | |
| t | 2524 | |
| v | 2524 | |
| A | 2523 | |
| o | 2523 | |
| e | 4 | < 0.1% |
| n | 3 | < 0.1% |
| d | 3 | < 0.1% |
| 2 | < 0.1% | |
| Other values (5) | 6 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 12634 | |
| Uppercase Letter | 2525 | 16.7% |
| Space Separator | 2 | < 0.1% |
| Other Number | 1 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 2526 | |
| c | 2524 | |
| t | 2524 | |
| v | 2524 | |
| o | 2523 | |
| e | 4 | < 0.1% |
| n | 3 | < 0.1% |
| d | 3 | < 0.1% |
| a | 2 | < 0.1% |
| l | 1 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 2523 | |
| P | 1 | < 0.1% |
| Ã | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 2 |
Other Number
| Value | Count | Frequency (%) |
| ³ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 15159 | |
| Common | 3 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 2526 | |
| c | 2524 | |
| t | 2524 | |
| v | 2524 | |
| A | 2523 | |
| o | 2523 | |
| e | 4 | < 0.1% |
| n | 3 | < 0.1% |
| d | 3 | < 0.1% |
| a | 2 | < 0.1% |
| Other values (3) | 3 | < 0.1% |
Common
| Value | Count | Frequency (%) |
| 2 | ||
| ³ | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 15160 | |
| None | 2 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 2526 | |
| c | 2524 | |
| t | 2524 | |
| v | 2524 | |
| A | 2523 | |
| o | 2523 | |
| e | 4 | < 0.1% |
| n | 3 | < 0.1% |
| d | 3 | < 0.1% |
| 2 | < 0.1% | |
| Other values (3) | 4 | < 0.1% |
None
| Value | Count | Frequency (%) |
| Ã | 1 | |
| ³ | 1 |
ciudad
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.8 KiB |
| GRAN | |
|---|---|
| VILLA | |
| ACA | |
| SM | |
| GRA | 1 |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 4.045166403 |
| Min length | 2 |
Characters and Unicode
| Total characters | 10210 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | GRA |
|---|---|
| 2nd row | GRAN |
| 3rd row | GRAN |
| 4th row | ACA |
| 5th row | GRAN |
Common Values
| Value | Count | Frequency (%) |
| GRAN | 1058 | |
| VILLA | 846 | |
| ACA | 507 | |
| SM | 112 | 4.4% |
| GRA | 1 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| gran | 1058 | |
| villa | 846 | |
| aca | 507 | |
| sm | 112 | 4.4% |
| gra | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 2919 | |
| L | 1692 | |
| G | 1059 | 10.4% |
| R | 1059 | 10.4% |
| N | 1058 | 10.4% |
| V | 846 | 8.3% |
| I | 846 | 8.3% |
| C | 507 | 5.0% |
| S | 112 | 1.1% |
| M | 112 | 1.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 10210 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 2919 | |
| L | 1692 | |
| G | 1059 | 10.4% |
| R | 1059 | 10.4% |
| N | 1058 | 10.4% |
| V | 846 | 8.3% |
| I | 846 | 8.3% |
| C | 507 | 5.0% |
| S | 112 | 1.1% |
| M | 112 | 1.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 10210 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 2919 | |
| L | 1692 | |
| G | 1059 | 10.4% |
| R | 1059 | 10.4% |
| N | 1058 | 10.4% |
| V | 846 | 8.3% |
| I | 846 | 8.3% |
| C | 507 | 5.0% |
| S | 112 | 1.1% |
| M | 112 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10210 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 2919 | |
| L | 1692 | |
| G | 1059 | 10.4% |
| R | 1059 | 10.4% |
| N | 1058 | 10.4% |
| V | 846 | 8.3% |
| I | 846 | 8.3% |
| C | 507 | 5.0% |
| S | 112 | 1.1% |
| M | 112 | 1.1% |
| Distinct | 60 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46.43779715 |
| Minimum | 19 |
|---|---|
| Maximum | 80 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.8 KiB |
Quantile statistics
| Minimum | 19 |
|---|---|
| 5-th percentile | 28 |
| Q1 | 37 |
| median | 46 |
| Q3 | 55 |
| 95-th percentile | 65 |
| Maximum | 80 |
| Range | 61 |
| Interquartile range (IQR) | 18 |
Descriptive statistics
| Standard deviation | 11.71739553 |
|---|---|
| Coefficient of variation (CV) | 0.2523245341 |
| Kurtosis | -0.7365723054 |
| Mean | 46.43779715 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 0.07877517473 |
| Sum | 117209 |
| Variance | 137.297358 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 39 | 82 | 3.2% |
| 37 | 81 | 3.2% |
| 43 | 80 | 3.2% |
| 49 | 76 | 3.0% |
| 44 | 73 | 2.9% |
| 48 | 72 | 2.9% |
| 41 | 71 | 2.8% |
| 50 | 71 | 2.8% |
| 45 | 70 | 2.8% |
| 40 | 70 | 2.8% |
| Other values (50) | 1778 |
| Value | Count | Frequency (%) |
| 19 | 1 | < 0.1% |
| 20 | 3 | 0.1% |
| 21 | 6 | 0.2% |
| 22 | 7 | 0.3% |
| 23 | 16 | |
| 24 | 17 | |
| 25 | 20 | |
| 26 | 14 | 0.6% |
| 27 | 26 | |
| 28 | 35 |
| Value | Count | Frequency (%) |
| 80 | 1 | < 0.1% |
| 79 | 2 | 0.1% |
| 76 | 3 | 0.1% |
| 75 | 4 | 0.2% |
| 74 | 3 | 0.1% |
| 73 | 5 | 0.2% |
| 72 | 5 | 0.2% |
| 71 | 8 | |
| 70 | 8 | |
| 69 | 15 |
genero
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.8 KiB |
| Femenino | |
|---|---|
| Masculino |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 8.357369255 |
| Min length | 8 |
Characters and Unicode
| Total characters | 21094 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Masculino |
|---|---|
| 2nd row | Masculino |
| 3rd row | Masculino |
| 4th row | Masculino |
| 5th row | Femenino |
Common Values
| Value | Count | Frequency (%) |
| Femenino | 1622 | |
| Masculino | 902 |
Length
Pie chart
| Value | Count | Frequency (%) |
| femenino | 1622 | |
| masculino | 902 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 4146 | |
| e | 3244 | |
| i | 2524 | |
| o | 2524 | |
| F | 1622 | 7.7% |
| m | 1622 | 7.7% |
| M | 902 | 4.3% |
| a | 902 | 4.3% |
| s | 902 | 4.3% |
| c | 902 | 4.3% |
| Other values (2) | 1804 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 18570 | |
| Uppercase Letter | 2524 | 12.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 4146 | |
| e | 3244 | |
| i | 2524 | |
| o | 2524 | |
| m | 1622 | 8.7% |
| a | 902 | 4.9% |
| s | 902 | 4.9% |
| c | 902 | 4.9% |
| u | 902 | 4.9% |
| l | 902 | 4.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 1622 | |
| M | 902 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 21094 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 4146 | |
| e | 3244 | |
| i | 2524 | |
| o | 2524 | |
| F | 1622 | 7.7% |
| m | 1622 | 7.7% |
| M | 902 | 4.3% |
| a | 902 | 4.3% |
| s | 902 | 4.3% |
| c | 902 | 4.3% |
| Other values (2) | 1804 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 21094 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 4146 | |
| e | 3244 | |
| i | 2524 | |
| o | 2524 | |
| F | 1622 | 7.7% |
| m | 1622 | 7.7% |
| M | 902 | 4.3% |
| a | 902 | 4.3% |
| s | 902 | 4.3% |
| c | 902 | 4.3% |
| Other values (2) | 1804 |
estrato
Real number (ℝ≥0)
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.188193344 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 3 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 3 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.8207592363 |
|---|---|
| Coefficient of variation (CV) | 0.3750853363 |
| Kurtosis | 0.3996171532 |
| Mean | 2.188193344 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.397895582 |
| Sum | 5523 |
| Variance | 0.673645724 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 1180 | |
| 3 | 736 | |
| 1 | 495 | |
| 4 | 93 | 3.7% |
| 5 | 14 | 0.6% |
| 0 | 3 | 0.1% |
| 6 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 3 | 0.1% |
| 1 | 495 | |
| 2 | 1180 | |
| 3 | 736 | |
| 4 | 93 | 3.7% |
| 5 | 14 | 0.6% |
| 6 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| 6 | 3 | 0.1% |
| 5 | 14 | 0.6% |
| 4 | 93 | 3.7% |
| 3 | 736 | |
| 2 | 1180 | |
| 1 | 495 | |
| 0 | 3 | 0.1% |
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.080031696 |
| Minimum | 0 |
|---|---|
| Maximum | 11 |
| Zeros | 1214 |
| Zeros (%) | 48.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.266951425 |
|---|---|
| Coefficient of variation (CV) | 1.173068744 |
| Kurtosis | 1.512745582 |
| Mean | 1.080031696 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.090012756 |
| Sum | 2726 |
| Variance | 1.605165913 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1214 | |
| 2 | 556 | |
| 1 | 398 | 15.8% |
| 3 | 247 | 9.8% |
| 4 | 82 | 3.2% |
| 5 | 20 | 0.8% |
| 6 | 6 | 0.2% |
| 11 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 1214 | |
| 1 | 398 | 15.8% |
| 2 | 556 | |
| 3 | 247 | 9.8% |
| 4 | 82 | 3.2% |
| 5 | 20 | 0.8% |
| 6 | 6 | 0.2% |
| 11 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 11 | 1 | < 0.1% |
| 6 | 6 | 0.2% |
| 5 | 20 | 0.8% |
| 4 | 82 | 3.2% |
| 3 | 247 | 9.8% |
| 2 | 556 | |
| 1 | 398 | 15.8% |
| 0 | 1214 |
activos
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONSKEWEDZEROS| Distinct | 262 |
|---|---|
| Distinct (%) | 10.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 219982523.1 |
| Minimum | 0 |
|---|---|
| Maximum | 2.50007 × 1011 |
| Zeros | 1005 |
| Zeros (%) | 39.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 5000000 |
| Q3 | 88250000 |
| 95-th percentile | 250000000 |
| Maximum | 2.50007 × 1011 |
| Range | 2.50007 × 1011 |
| Interquartile range (IQR) | 88250000 |
Descriptive statistics
| Standard deviation | 5802217285 |
|---|---|
| Coefficient of variation (CV) | 26.37581024 |
| Kurtosis | 1538.062468 |
| Mean | 219982523.1 |
| Median Absolute Deviation (MAD) | 5000000 |
| Skewness | 38.47219861 |
| Sum | 5.552358882 × 1011 |
| Variance | 3.366572542 × 1019 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1005 | |
| 1 | 126 | 5.0% |
| 150000000 | 92 | 3.6% |
| 50000000 | 66 | 2.6% |
| 100000000 | 65 | 2.6% |
| 200000000 | 63 | 2.5% |
| 5000000 | 52 | 2.1% |
| 80000000 | 41 | 1.6% |
| 30000000 | 41 | 1.6% |
| 60000000 | 40 | 1.6% |
| Other values (252) | 933 |
| Value | Count | Frequency (%) |
| 0 | 1005 | |
| 1 | 126 | 5.0% |
| 2 | 3 | 0.1% |
| 4 | 2 | 0.1% |
| 35 | 1 | < 0.1% |
| 100000 | 3 | 0.1% |
| 150000 | 1 | < 0.1% |
| 200000 | 2 | 0.1% |
| 240000 | 1 | < 0.1% |
| 300000 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| 2.50007 × 1011 | 1 | |
| 1.5 × 1011 | 1 | |
| 4050000000 | 1 | |
| 2010000000 | 1 | |
| 1200000000 | 1 | |
| 955000000 | 1 | |
| 850000000 | 2 | |
| 844300000 | 1 | |
| 800000000 | 1 | |
| 740000000 | 1 |
| Distinct | 288 |
|---|---|
| Distinct (%) | 11.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27934840.26 |
| Minimum | 0 |
|---|---|
| Maximum | 2500000000 |
| Zeros | 1037 |
| Zeros (%) | 41.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 965000 |
| Q3 | 40000000 |
| 95-th percentile | 120000000 |
| Maximum | 2500000000 |
| Range | 2500000000 |
| Interquartile range (IQR) | 40000000 |
Descriptive statistics
| Standard deviation | 69282001.47 |
|---|---|
| Coefficient of variation (CV) | 2.480128786 |
| Kurtosis | 648.0347743 |
| Mean | 27934840.26 |
| Median Absolute Deviation (MAD) | 965000 |
| Skewness | 19.27261303 |
| Sum | 7.050753682 × 1010 |
| Variance | 4.799995728 × 1015 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1037 | |
| 1 | 126 | 5.0% |
| 50000000 | 62 | 2.5% |
| 30000000 | 56 | 2.2% |
| 100000000 | 50 | 2.0% |
| 40000000 | 48 | 1.9% |
| 20000000 | 47 | 1.9% |
| 60000000 | 46 | 1.8% |
| 80000000 | 44 | 1.7% |
| 10000000 | 35 | 1.4% |
| Other values (278) | 973 |
| Value | Count | Frequency (%) |
| 0 | 1037 | |
| 1 | 126 | 5.0% |
| 2 | 5 | 0.2% |
| 24500 | 1 | < 0.1% |
| 30000 | 1 | < 0.1% |
| 50000 | 1 | < 0.1% |
| 100000 | 9 | 0.4% |
| 150000 | 2 | 0.1% |
| 180000 | 1 | < 0.1% |
| 200000 | 6 | 0.2% |
| Value | Count | Frequency (%) |
| 2500000000 | 1 | < 0.1% |
| 700000000 | 1 | < 0.1% |
| 500000000 | 1 | < 0.1% |
| 450000000 | 2 | 0.1% |
| 360000000 | 1 | < 0.1% |
| 331200000 | 1 | < 0.1% |
| 300000000 | 1 | < 0.1% |
| 265000000 | 1 | < 0.1% |
| 250000000 | 5 | |
| 240000000 | 1 | < 0.1% |
patrimonio
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONSKEWEDZEROS| Distinct | 603 |
|---|---|
| Distinct (%) | 23.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 190867161.4 |
| Minimum | -2325000000 |
|---|---|
| Maximum | 2.49952 × 1011 |
| Zeros | 1153 |
| Zeros (%) | 45.7% |
| Negative | 355 |
| Negative (%) | 14.1% |
| Memory size | 19.8 KiB |
Quantile statistics
| Minimum | -2325000000 |
|---|---|
| 5-th percentile | -38000000 |
| Q1 | 0 |
| median | 0 |
| Q3 | 33700000 |
| 95-th percentile | 191700000 |
| Maximum | 2.49952 × 1011 |
| Range | 2.52277 × 1011 |
| Interquartile range (IQR) | 33700000 |
Descriptive statistics
| Standard deviation | 5801898577 |
|---|---|
| Coefficient of variation (CV) | 30.39757355 |
| Kurtosis | 1537.970322 |
| Mean | 190867161.4 |
| Median Absolute Deviation (MAD) | 3000000 |
| Skewness | 38.47257644 |
| Sum | 4.817487154 × 1011 |
| Variance | 3.36620271 × 1019 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1153 | |
| 20000000 | 36 | 1.4% |
| 70000000 | 33 | 1.3% |
| 10000000 | 30 | 1.2% |
| 50000000 | 27 | 1.1% |
| 30000000 | 27 | 1.1% |
| 100000000 | 19 | 0.8% |
| 150000000 | 15 | 0.6% |
| 1000000 | 15 | 0.6% |
| 5000000 | 15 | 0.6% |
| Other values (593) | 1154 |
| Value | Count | Frequency (%) |
| -2325000000 | 1 | |
| -655000000 | 1 | |
| -220000000 | 1 | |
| -150000000 | 1 | |
| -148600000 | 1 | |
| -140000000 | 1 | |
| -130000000 | 1 | |
| -127000000 | 1 | |
| -120000000 | 1 | |
| -115500000 | 1 |
| Value | Count | Frequency (%) |
| 2.49952 × 1011 | 1 | |
| 1.499995 × 1011 | 1 | |
| 4047000000 | 1 | |
| 1510000000 | 1 | |
| 1175000000 | 1 | |
| 800000000 | 1 | |
| 730000000 | 1 | |
| 725000000 | 1 | |
| 641000000 | 1 | |
| 600000000 | 1 |
| Distinct | 1329 |
|---|---|
| Distinct (%) | 52.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3181291.113 |
| Minimum | 1 |
|---|---|
| Maximum | 50919989 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1167812 |
| Q1 | 1896063 |
| median | 2633097 |
| Q3 | 3919989 |
| 95-th percentile | 6940665.25 |
| Maximum | 50919989 |
| Range | 50919988 |
| Interquartile range (IQR) | 2023926 |
Descriptive statistics
| Standard deviation | 2270543.211 |
|---|---|
| Coefficient of variation (CV) | 0.7137175223 |
| Kurtosis | 101.6720346 |
| Mean | 3181291.113 |
| Median Absolute Deviation (MAD) | 900835.5 |
| Skewness | 6.629771286 |
| Sum | 8029578769 |
| Variance | 5.155366472 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2209679 | 87 | 3.4% |
| 1896063 | 48 | 1.9% |
| 2290026 | 41 | 1.6% |
| 4398643 | 40 | 1.6% |
| 1621543 | 31 | 1.2% |
| 3641927 | 29 | 1.1% |
| 1755704 | 29 | 1.1% |
| 2040828 | 28 | 1.1% |
| 4244314 | 26 | 1.0% |
| 4000000 | 25 | 1.0% |
| Other values (1319) | 2140 |
| Value | Count | Frequency (%) |
| 1 | 2 | |
| 616000 | 1 | < 0.1% |
| 689454 | 1 | < 0.1% |
| 689455 | 1 | < 0.1% |
| 708230 | 1 | < 0.1% |
| 731852 | 1 | < 0.1% |
| 737717 | 1 | < 0.1% |
| 740000 | 1 | < 0.1% |
| 781242 | 4 | |
| 791769 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 50919989 | 1 | |
| 35555000 | 1 | |
| 25000000 | 1 | |
| 21567708 | 1 | |
| 19200000 | 1 | |
| 19000000 | 1 | |
| 16745211 | 1 | |
| 15224282 | 1 | |
| 12919989 | 1 | |
| 12800000 | 1 |
| Distinct | 280 |
|---|---|
| Distinct (%) | 11.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1392213.583 |
| Minimum | 0 |
|---|---|
| Maximum | 301500000 |
| Zeros | 882 |
| Zeros (%) | 34.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 755000 |
| Q3 | 1585000 |
| 95-th percentile | 3643450 |
| Maximum | 301500000 |
| Range | 301500000 |
| Interquartile range (IQR) | 1585000 |
Descriptive statistics
| Standard deviation | 7233586.331 |
|---|---|
| Coefficient of variation (CV) | 5.195744691 |
| Kurtosis | 1222.356657 |
| Mean | 1392213.583 |
| Median Absolute Deviation (MAD) | 755000 |
| Skewness | 31.83263709 |
| Sum | 3513947083 |
| Variance | 5.232477121 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 882 | |
| 1000000 | 188 | 7.4% |
| 2000000 | 123 | 4.9% |
| 1500000 | 104 | 4.1% |
| 800000 | 101 | 4.0% |
| 500000 | 93 | 3.7% |
| 600000 | 87 | 3.4% |
| 1200000 | 74 | 2.9% |
| 700000 | 66 | 2.6% |
| 3000000 | 57 | 2.3% |
| Other values (270) | 749 |
| Value | Count | Frequency (%) |
| 0 | 882 | |
| 1 | 5 | 0.2% |
| 4 | 1 | < 0.1% |
| 100000 | 11 | 0.4% |
| 140000 | 1 | < 0.1% |
| 200000 | 9 | 0.4% |
| 220000 | 1 | < 0.1% |
| 250000 | 2 | 0.1% |
| 300000 | 33 | 1.3% |
| 327500 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 301500000 | 1 | |
| 119000000 | 1 | |
| 102500000 | 1 | |
| 62926000 | 1 | |
| 61000000 | 1 | |
| 51500000 | 1 | |
| 40000002 | 1 | |
| 30000000 | 1 | |
| 27990000 | 1 | |
| 16600000 | 1 |
no_productos
Real number (ℝ≥0)
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.54318542 |
| Minimum | 1 |
|---|---|
| Maximum | 9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 9 |
| Range | 8 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.7752341748 |
|---|---|
| Coefficient of variation (CV) | 0.5023597066 |
| Kurtosis | 5.769445993 |
| Mean | 1.54318542 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.804606453 |
| Sum | 3895 |
| Variance | 0.6009880259 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1492 | |
| 2 | 768 | |
| 3 | 208 | 8.2% |
| 4 | 43 | 1.7% |
| 5 | 10 | 0.4% |
| 6 | 2 | 0.1% |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 1492 | |
| 2 | 768 | |
| 3 | 208 | 8.2% |
| 4 | 43 | 1.7% |
| 5 | 10 | 0.4% |
| 6 | 2 | 0.1% |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9 | 1 | < 0.1% |
| 6 | 2 | 0.1% |
| 5 | 10 | 0.4% |
| 4 | 43 | 1.7% |
| 3 | 208 | 8.2% |
| 2 | 768 | |
| 1 | 1492 |
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.8 KiB |
| A | |
|---|---|
| E | 78 |
| B | 32 |
| D | 15 |
| C | 8 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 2524 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 2391 | |
| E | 78 | 3.1% |
| B | 32 | 1.3% |
| D | 15 | 0.6% |
| C | 8 | 0.3% |
Length
Pie chart
| Value | Count | Frequency (%) |
| a | 2391 | |
| e | 78 | 3.1% |
| b | 32 | 1.3% |
| d | 15 | 0.6% |
| c | 8 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 2391 | |
| E | 78 | 3.1% |
| B | 32 | 1.3% |
| D | 15 | 0.6% |
| C | 8 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2524 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 2391 | |
| E | 78 | 3.1% |
| B | 32 | 1.3% |
| D | 15 | 0.6% |
| C | 8 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2524 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 2391 | |
| E | 78 | 3.1% |
| B | 32 | 1.3% |
| D | 15 | 0.6% |
| C | 8 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2524 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 2391 | |
| E | 78 | 3.1% |
| B | 32 | 1.3% |
| D | 15 | 0.6% |
| C | 8 | 0.3% |
| Distinct | 63 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.99207607 |
| Minimum | 0 |
|---|---|
| Maximum | 3630 |
| Zeros | 2266 |
| Zeros (%) | 89.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 55 |
| Maximum | 3630 |
| Range | 3630 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 181.3668933 |
|---|---|
| Coefficient of variation (CV) | 6.255740117 |
| Kurtosis | 118.6926099 |
| Mean | 28.99207607 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.634143471 |
| Sum | 73176 |
| Variance | 32893.95 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2266 | |
| 25 | 107 | 4.2% |
| 55 | 26 | 1.0% |
| 30 | 20 | 0.8% |
| 85 | 6 | 0.2% |
| 175 | 5 | 0.2% |
| 235 | 4 | 0.2% |
| 450 | 4 | 0.2% |
| 295 | 4 | 0.2% |
| 570 | 3 | 0.1% |
| Other values (53) | 79 | 3.1% |
| Value | Count | Frequency (%) |
| 0 | 2266 | |
| 25 | 107 | 4.2% |
| 30 | 20 | 0.8% |
| 55 | 26 | 1.0% |
| 60 | 3 | 0.1% |
| 85 | 6 | 0.2% |
| 90 | 3 | 0.1% |
| 115 | 3 | 0.1% |
| 145 | 3 | 0.1% |
| 150 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 3630 | 1 | |
| 2459 | 1 | |
| 2152 | 1 | |
| 1980 | 1 | |
| 1830 | 1 | |
| 1795 | 1 | |
| 1740 | 1 | |
| 1735 | 1 | |
| 1680 | 1 | |
| 1675 | 1 |
| Distinct | 2271 |
|---|---|
| Distinct (%) | 90.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10443854.11 |
| Minimum | 0 |
|---|---|
| Maximum | 257318078 |
| Zeros | 206 |
| Zeros (%) | 8.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 605599.5 |
| median | 2106686.5 |
| Q3 | 10442965.75 |
| 95-th percentile | 49406588.3 |
| Maximum | 257318078 |
| Range | 257318078 |
| Interquartile range (IQR) | 9837366.25 |
Descriptive statistics
| Standard deviation | 19720873.12 |
|---|---|
| Coefficient of variation (CV) | 1.88827543 |
| Kurtosis | 20.95712341 |
| Mean | 10443854.11 |
| Median Absolute Deviation (MAD) | 1937246 |
| Skewness | 3.691864227 |
| Sum | 2.636028778 × 1010 |
| Variance | 3.889128366 × 1014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 206 | 8.2% |
| 750450 | 27 | 1.1% |
| 500300 | 5 | 0.2% |
| 400240 | 4 | 0.2% |
| 550330 | 3 | 0.1% |
| 350210 | 2 | 0.1% |
| 6809756 | 2 | 0.1% |
| 600360 | 2 | 0.1% |
| 404752 | 2 | 0.1% |
| 300180 | 2 | 0.1% |
| Other values (2261) | 2269 |
| Value | Count | Frequency (%) |
| 0 | 206 | |
| 2 | 1 | < 0.1% |
| 561 | 1 | < 0.1% |
| 1149 | 1 | < 0.1% |
| 1485 | 1 | < 0.1% |
| 5951 | 1 | < 0.1% |
| 23365 | 1 | < 0.1% |
| 26146 | 1 | < 0.1% |
| 46961 | 1 | < 0.1% |
| 47094 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 257318078 | 1 | |
| 178985144 | 1 | |
| 158988393 | 1 | |
| 154331658 | 1 | |
| 134666076 | 1 | |
| 133645264 | 1 | |
| 129749791 | 1 | |
| 129245037 | 1 | |
| 119474394 | 1 | |
| 111360398 | 1 |
mora
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONSKEWEDZEROS| Distinct | 2292 |
|---|---|
| Distinct (%) | 90.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1197997.478 |
| Minimum | 0 |
|---|---|
| Maximum | 163603870 |
| Zeros | 157 |
| Zeros (%) | 6.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 235551.25 |
| median | 532156 |
| Q3 | 1253856.5 |
| 95-th percentile | 3284678.15 |
| Maximum | 163603870 |
| Range | 163603870 |
| Interquartile range (IQR) | 1018305.25 |
Descriptive statistics
| Standard deviation | 4587891.652 |
|---|---|
| Coefficient of variation (CV) | 3.829633814 |
| Kurtosis | 699.2558484 |
| Mean | 1197997.478 |
| Median Absolute Deviation (MAD) | 383000.5 |
| Skewness | 23.1708264 |
| Sum | 3023745635 |
| Variance | 2.104874981 × 1013 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 0 | 157 | 6.2% |
| 385584 | 27 | 1.1% |
| 205645 | 5 | 0.2% |
| 257056 | 5 | 0.2% |
| 528658 | 3 | 0.1% |
| 282762 | 3 | 0.1% |
| 179939 | 3 | 0.1% |
| 664664 | 3 | 0.1% |
| 353604 | 3 | 0.1% |
| 107145 | 2 | 0.1% |
| Other values (2282) | 2313 |
| Value | Count | Frequency (%) |
| 0 | 157 | |
| 174 | 1 | < 0.1% |
| 2160 | 2 | 0.1% |
| 3000 | 2 | 0.1% |
| 6271 | 1 | < 0.1% |
| 9000 | 2 | 0.1% |
| 11157 | 1 | < 0.1% |
| 12000 | 1 | < 0.1% |
| 12844 | 1 | < 0.1% |
| 17592 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 163603870 | 1 | |
| 78433507 | 1 | |
| 75132454 | 1 | |
| 55830006 | 1 | |
| 52220345 | 1 | |
| 45265705 | 1 | |
| 31283561 | 1 | |
| 25426725 | 1 | |
| 25358948 | 1 | |
| 24459090 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| cedula | nombre | antiguedad | activo | ciudad | edad | genero | tipo_vivienda | estrato | ocupacion | nivel_academico | no_hijos | personas_a_cargo | tiene_casa | tiene_carro | estado_civil | tipo_contrato | activos | pasivos | patrimonio | salario | gastos | entidad | no_productos | calificacion | dias_mora | saldo_total | mora | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 10000 | JORGE ELIECER ALDANA AMADOR | 4 | Activo | GRA | 54 | Masculino | ARRENDADA | 2 | DOCENTE | Universitario | 4 | Cuatro o mas | 0 | 0 | Casado | A término Indefinido | 1 | 1 | 0 | 1149906 | 1000000 | GOB MT | 1 | A | 0 | 492687.0 | 0 |
| 1 | 11000 | ELKIN ARLEY CASTRO VELANDIA | 1 | Activo | GRAN | 29 | Masculino | PROPIA | 2 | EMPLEADO PUBLICO NO DOCENTE | Técnico | 0 | Cero | 0 | 0 | Union Libre | A término Indefinido | 100000000 | 16000000 | 0 | 1228925 | 1000000 | EJER NAL | 1 | A | 0 | 395715.0 | 0 |
| 2 | 12000 | HERSSON FERNANDO FLOREZ MORENO | 6 | Activo | GRAN | 29 | Masculino | FAMILIAR | 3 | DOCENTE | Técnico | 1 | Una | N | N | Soltero | A término Fijo | 1 | 84000000 | -83999999 | 2319409 | 1540000 | GOB MT | 1 | A | 0 | 603910.0 | 0 |
| 3 | 13000 | BRAYAN ALEXANDER BARON ORTEGON | 0 | Activo | ACA | 31 | Masculino | ARRENDADA | 2 | Tecnico | Universitario | 0 | Cero | 0 | 0 | Soltero | A término Indefinido | 0 | 0 | 0 | 1854448 | 900000 | MPIO EL DORA | 1 | A | 0 | 631766.0 | 0 |
| 4 | 14000 | CINDY MAYELA OCHOA HERNANDEZ | 5 | Activo | GRAN | 34 | Femenino | PROPIA | 2 | DOCENTE | Especializacion | 1 | Una | 0 | 0 | Casado | A término Indefinido | 150000000 | 67000000 | 83000000 | 2489102 | 1000000 | GOB MT | 1 | A | 0 | 0.0 | 0 |
| 5 | 15000 | LEIDY JOHANA PARRADO GALINDEZ | 17 | Activo | GRAN | 36 | Femenino | PROPIA | 1 | DOCENTE SECUNDARIA | Universitario | 1 | Una | N | N | Union Libre | A término Indefinido | 200000000 | 100000000 | 100000000 | 7576449 | 800000 | GOB MT | 1 | A | 0 | 38563398.0 | 0 |
| 6 | 16000 | CAMILO ANDRES HIGUAVITA CORREA | 0 | Activo | VILLA | 36 | Masculino | ARRENDADA | 3 | CONTRATISTA | Tecnológico | 1 | Una | N | N | Soltero | A término Indefinido | 35000000 | 1000000 | 0 | 2189163 | 800000 | MUNICIPIO DE PTO GAI | 1 | A | 0 | 333834.0 | 0 |
| 7 | 17000 | LEIDY ALEXANDRA NARANJO LOZANO | 0 | Activo | GRAN | 39 | Femenino | PROPIA | 2 | CONTADOR (A) | Universitario | 2 | Tres | N | N | Separaci?n Judicial | A término Fijo | 102000000 | 20000000 | 0 | 2511300 | 600000 | SOC SALEC | 1 | A | 0 | 556867.0 | 0 |
| 8 | 18000 | MARIA LUZ DARY ABRIL NIÑO | 7 | Activo | ACA | 55 | Femenino | ARRENDADA | 2 | DOCENTE | Especializacion | 3 | Una | 0 | 0 | Soltero | A término Indefinido | 10000000 | 60000000 | -50000000 | 4244314 | 800000 | GOB MT | 1 | A | 0 | 100640.0 | 0 |
| 9 | 19000 | ALONSO BONILLA NIÑO | 0 | Activo | ACA | 61 | Masculino | PROPIA | 4 | TECNOLOGO | Tecnológico | 0 | Una | N | N | Casado | A término Fijo | 240000000 | 35000000 | 205000000 | 2576925 | 1000000 | HOSP ACA | 1 | A | 0 | 0.0 | 0 |
Last rows
| cedula | nombre | antiguedad | activo | ciudad | edad | genero | tipo_vivienda | estrato | ocupacion | nivel_academico | no_hijos | personas_a_cargo | tiene_casa | tiene_carro | estado_civil | tipo_contrato | activos | pasivos | patrimonio | salario | gastos | entidad | no_productos | calificacion | dias_mora | saldo_total | mora | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2514 | 2524000 | EMMA IDE ALFONSO ALFONSO | 13 | Activo | VILLA | 42 | Femenino | PROPIA | 1 | Otros | Universitario | 0 | Cero | 0 | 0 | Union Libre | A término Indefinido | 0 | 0 | 0 | 2406519 | 0 | GOB MT | 3 | E | 955 | 13574761.0 | 24459090 |
| 2515 | 2525000 | ROSA ELENA CARDOZO HERMOSA | 9 | Activo | GRAN | 54 | Femenino | PROPIA | 2 | Otros | Bachillerato | 0 | Una | 0 | 0 | Soltero | A término Indefinido | 0 | 0 | 0 | 791769 | 0 | MPIO JUAN | 9 | A | 30 | 3649086.0 | 25358948 |
| 2516 | 2526000 | MARLY YISETH BUITRAGO MONTEALEGRE | 9 | Activo | GRAN | 31 | Femenino | ARRENDADA | 1 | Otros | Tecnológico | 0 | Cero | 0 | 0 | Casado | A término Fijo | 0 | 0 | 0 | 850000 | 0 | CONC S JUAN | 3 | E | 1255 | 12703438.0 | 25426725 |
| 2517 | 2527000 | FLOR DEL CARMEN MEDINA MARTIN | 6 | Activo | VILLA | 55 | Femenino | PROPIA | 3 | Otros | Postgrado | 0 | Una | 0 | 0 | Casado | Otra | 0 | 0 | 0 | 6133182 | 0 | PREVI S.A. | 1 | E | 960 | 20906958.0 | 31283561 |
| 2518 | 2528000 | GUILLERMO TOBON BORRERO | 6 | Activo | VILLA | 62 | Masculino | PROPIA | 3 | Otros | Postgrado | 0 | Cero | 0 | 0 | Casado | A término Indefinido | 0 | 0 | 0 | 3120336 | 0 | MUN VCIO | 4 | E | 1735 | 13884066.0 | 45265705 |
| 2519 | 2529000 | OFELIA PEREZ | 21 | Activo | GRAN | 63 | Femenino | ARRENDADA | 2 | Otros | Tecnológico | 0 | Cero | 0 | 0 | Union Libre | 0 | 0 | 0 | 0 | 1167812 | 0 | 0 | 2 | E | 990 | 12678497.0 | 52220345 |
| 2520 | 2530000 | DORIS EDIT PARRADO PARRADO | 7 | Activo | GRAN | 56 | Femenino | PROPIA | 3 | Otros | Técnico | 0 | Cero | 0 | 0 | Soltero | 0 | 0 | 0 | 0 | 3300000 | 0 | 0 | 1 | E | 1740 | 26341773.0 | 55830006 |
| 2521 | 2531000 | LUIS HERLEY JIMENEZ VALENCIA | 6 | Activo | VILLA | 53 | Masculino | PROPIA | 3 | Otros | Bachillerato | 0 | Cero | 0 | 0 | Casado | A término Indefinido | 0 | 0 | 0 | 2402900 | 0 | MUN VCIO | 6 | E | 1345 | 26442992.0 | 75132454 |
| 2522 | 2532000 | ANGELICA MARIA BLANCO QUINTERO | 13 | Activo | VILLA | 43 | Femenino | PROPIA | 3 | Otros | Postgrado | 0 | Cero | 0 | 0 | Casado | A término Indefinido | 0 | 0 | 0 | 5872590 | 0 | MUN VCIO | 3 | E | 865 | 17119909.0 | 78433507 |
| 2523 | 2533000 | LUIS MIGUEL DIAZ CUBIDES | 21 | Activo | VILLA | 61 | Masculino | PROPIA | 3 | Otros | Postgrado | 0 | Cero | 0 | 0 | Union Libre | 0 | 0 | 0 | 0 | 2129772 | 0 | 0 | 1 | E | 3630 | 39753981.0 | 163603870 |